//
//    Copyright (C) 2012  OinkStudio
//
//    This program is free software: you can redistribute it and/or modify
//    it under the terms of the GNU General Public License as published by
//    the Free Software Foundation, either version 3 of the License, or
//    (at your option) any later version.
//
//    This program is distributed in the hope that it will be useful,
//    but WITHOUT ANY WARRANTY; without even the implied warranty of
//    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
//    GNU General Public License for more details.
//
//    You should have received a copy of the GNU General Public License
//    along with this program.  If not, see <http://www.gnu.org/licenses/>.

package database;

public class GlobalValues {

	static final String taulaEspecial = "productes";
	
	static final String queryProductes = "SELECT idProducte, productes.descripcio, productes.nom, preu,"
			+ " isbn, unitatsExistencia, tipusProductes.nomTipus, autors.nomAutor, categoria, minimJugadors,"
			+ " maximJugadors, edat, fabricants.nomFabricant, puntuacio, duracio FROM productes JOIN tipusProductes"
			+ " ON productes.idTipus = tipusProductes.idTipus JOIN autors ON productes.idAutor = autors.idAutor"
			+ " JOIN fabricants ON productes.idFabricant = fabricants.idFabricant ORDER BY idProducte;";
	
	
}
